SELECT col7 , col1 , LAG(col1) OVER(PARTITION BY col7 ORDER BY col1) LAG_col1 FROM "allTypsUniq.parquet" WHERE col1 IN (9223372036854775807,-1,0,1,4611686018427387903,13,27,197,17,10000000)